Kansas_City

Dataset statistics

Number of variables	23
Number of observations	1563215
Missing cells	2595087
Missing cells (%)	7.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	274.3 MiB
Average record size in memory	184.0 B

Variable types

Numeric	6
Categorical	7
Text	6
DateTime	3
Boolean	1

Alerts

`SOURCE` is highly imbalanced (72.5%)	Imbalance
`DEPARTMENT` is highly imbalanced (55.9%)	Imbalance
`STATUS` is highly imbalanced (94.2%)	Imbalance
`COUNTY` is highly imbalanced (74.4%)	Imbalance
`DAYS TO CLOSE` has 26515 (1.7%) missing values	Missing
`NEIGHBORHOOD` has 46106 (2.9%) missing values	Missing
`COUNTY` has 66959 (4.3%) missing values	Missing
`POLICE DISTRICT` has 35265 (2.3%) missing values	Missing
`CATEGORY2` has 1001657 (64.1%) missing values	Missing
`CATEGORY3` has 1404943 (89.9%) missing values	Missing
`ZIP CODE` is highly skewed (γ1 = -832.06849)	Skewed
`PARCEL ID NO` is highly skewed (γ1 = 250.9088658)	Skewed
`CASE ID` has unique values	Unique
`DAYS TO CLOSE` has 150614 (9.6%) zeros	Zeros
`PARCEL ID NO` has 35266 (2.3%) zeros	Zeros

Reproduction

Analysis started	2024-02-28 09:25:25.068614
Analysis finished	2024-02-28 09:34:12.120086
Duration	8 minutes and 47.05 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

CASE ID
Real number (ℝ)

UNIQUE

Distinct	1563215
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0140133 × 10⁹

Minimum	2.006 × 10⁹
Maximum	2.0210337 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	2.006 × 10⁹
5-th percentile	2.0071832 × 10⁹
Q1	2.0101856 × 10⁹
median	2.0140975 × 10⁹
Q3	2.0180632 × 10⁹
95-th percentile	2.0200896 × 10⁹
Maximum	2.0210337 × 10⁹
Range	15033684
Interquartile range (IQR)	7877594

Descriptive statistics

Standard deviation	4222588.7
Coefficient of variation (CV)	0.0020966042
Kurtosis	-1.3391166
Mean	2.0140133 × 10⁹
Median Absolute Deviation (MAD)	3950638
Skewness	-0.072037995
Sum	3.1483358 × 10¹⁵
Variance	1.7830256 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2019119972	1	< 0.1%
2015045877	1	< 0.1%
2015040302	1	< 0.1%
2015041682	1	< 0.1%
2015049038	1	< 0.1%
2015034811	1	< 0.1%
2015041579	1	< 0.1%
2015042453	1	< 0.1%
2015052481	1	< 0.1%
2015043953	1	< 0.1%
Other values (1563205)	1563205	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2006000002	1	< 0.1%
2006000004	1	< 0.1%
2007000001	1	< 0.1%
2007000005	1	< 0.1%
2007000009	1	< 0.1%
2007000010	1	< 0.1%
2007000012	1	< 0.1%
2007000013	1	< 0.1%
2007000014	1	< 0.1%
2007000015	1	< 0.1%

Value	Count	Frequency (%)
2021033686	1	< 0.1%
2021033407	1	< 0.1%
2021033233	1	< 0.1%
2021033140	1	< 0.1%
2021032869	1	< 0.1%
2021032828	1	< 0.1%
2021032612	1	< 0.1%
2021032575	1	< 0.1%
2021032525	1	< 0.1%
2021032480	1	< 0.1%

SOURCE
Categorical

IMBALANCE

Distinct	21
Distinct (%)	< 0.1%
Missing	67
Missing (%)	< 0.1%
Memory size	11.9 MiB

PHONE	1204236
WEB	211721
EMAIL	80585
SYS	19226
INSPE	14690
Other values (16)	32690

Length

Max length	5
Median length	5
Mean length	4.677877
Min length	3

Characters and Unicode

Total characters	7312214
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PHONE
2nd row	WEB
3rd row	PHONE
4th row	PHONE
5th row	WEB

Common Values

Value	Count	Frequency (%)
PHONE	1204236	77.0%
WEB	211721	13.5%
EMAIL	80585	5.2%
SYS	19226	1.2%
INSPE	14690	0.9%
BOT	13396	0.9%
TWIR	8311	0.5%
VOICE	6021	0.4%
WALK	1792	0.1%
FAX	1538	0.1%
Other values (11)	1632	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
phone	1204236	77.0%
web	211721	13.5%
email	80585	5.2%
sys	19226	1.2%
inspe	14690	0.9%
bot	13396	0.9%
twir	8311	0.5%
voice	6021	0.4%
walk	1792	0.1%
fax	1538	0.1%
Other values (11)	1632	0.1%

Most occurring characters

Value	Count	Frequency (%)
E	1518427	20.8%
O	1223712	16.7%
P	1219913	16.7%
N	1218950	16.7%
H	1204260	16.5%
B	225129	3.1%
W	221824	3.0%
I	110312	1.5%
A	84238	1.2%
L	82700	1.1%
Other values (12)	202749	2.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7312214	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1518427	20.8%
O	1223712	16.7%
P	1219913	16.7%
N	1218950	16.7%
H	1204260	16.5%
B	225129	3.1%
W	221824	3.0%
I	110312	1.5%
A	84238	1.2%
L	82700	1.1%
Other values (12)	202749	2.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7312214	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1518427	20.8%
O	1223712	16.7%
P	1219913	16.7%
N	1218950	16.7%
H	1204260	16.5%
B	225129	3.1%
W	221824	3.0%
I	110312	1.5%
A	84238	1.2%
L	82700	1.1%
Other values (12)	202749	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7312214	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1518427	20.8%
O	1223712	16.7%
P	1219913	16.7%
N	1218950	16.7%
H	1204260	16.5%
B	225129	3.1%
W	221824	3.0%
I	110312	1.5%
A	84238	1.2%
L	82700	1.1%
Other values (12)	202749	2.8%

DEPARTMENT
Categorical

IMBALANCE

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

NHS	783094
Public Works	353787
Water Services	216852
Parks and Rec	87954
Health	39543
Other values (22)	81985

Length

Max length	35
Median length	3
Mean length	7.6318446
Min length	2

Characters and Unicode

Total characters	11930214
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	NHS
2nd row	Public Works
3rd row	NHS
4th row	NHS
5th row	Parks and Rec

Common Values

Value	Count	Frequency (%)
NHS	783094	50.1%
Public Works	353787	22.6%
Water Services	216852	13.9%
Parks and Rec	87954	5.6%
Health	39543	2.5%
KCPD	36369	2.3%
City Managers Office	13098	0.8%
City Planning and Development	12575	0.8%
Northland	8591	0.5%
NCS	6391	0.4%
Other values (17)	4961	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nhs	783094	32.9%
public	353787	14.9%
works	353787	14.9%
water	216852	9.1%
services	216852	9.1%
and	100588	4.2%
parks	88826	3.7%
rec	88815	3.7%
health	39543	1.7%
kcpd	36369	1.5%
Other values (32)	98741	4.2%

Most occurring characters

Value	Count	Frequency (%)
S	1007164	8.4%
r	900261	7.5%
e	847896	7.1%
H	822980	6.9%
	814039	6.8%
N	798111	6.7%
c	675143	5.7%
s	672981	5.6%
i	626675	5.3%
W	570639	4.8%
Other values (30)	4194325	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7151431	59.9%
Uppercase Letter	3963872	33.2%
Space Separator	814039	6.8%
Other Punctuation	872	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	900261	12.6%
e	847896	11.9%
c	675143	9.4%
s	672981	9.4%
i	626675	8.8%
a	496002	6.9%
k	442615	6.2%
l	427997	6.0%
o	376777	5.3%
u	355543	5.0%
Other values (11)	1329541	18.6%

Uppercase Letter

Value	Count	Frequency (%)
S	1007164	25.4%
H	822980	20.8%
N	798111	20.1%
W	570639	14.4%
P	491557	12.4%
R	88827	2.2%
C	69282	1.7%
D	49286	1.2%
K	36369	0.9%
M	13514	0.3%
Other values (7)	16143	0.4%

Space Separator

Value	Count	Frequency (%)
	814039	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	872	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11115303	93.2%
Common	814911	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	1007164	9.1%
r	900261	8.1%
e	847896	7.6%
H	822980	7.4%
N	798111	7.2%
c	675143	6.1%
s	672981	6.1%
i	626675	5.6%
W	570639	5.1%
a	496002	4.5%
Other values (28)	3697451	33.3%

Common

Value	Count	Frequency (%)
	814039	99.9%
&	872	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11930214	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	1007164	8.4%
r	900261	7.5%
e	847896	7.1%
H	822980	6.9%
	814039	6.8%
N	798111	6.7%
c	675143	5.7%
s	672981	5.6%
i	626675	5.3%
W	570639	4.8%
Other values (30)	4194325	35.2%

WORK GROUP
Text

Distinct	146
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Length

Max length	50
Median length	47
Mean length	31.048004
Min length	6

Characters and Unicode

Total characters	48534706
Distinct characters	53
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	NHS-Dangerous Buildings-
2nd row	Public Works-Street and Traffic-District 1
3rd row	NHS-Dangerous Buildings-
4th row	NHS-Neighborhood Preservation-
5th row	Parks and Rec-Central Region-

Value	Count	Frequency (%)
and	497876	10.5%
public	353787	7.5%
waste	337776	7.2%
nhs-neighborhood	317500	6.7%
nhs-solid	299322	6.3%
preservation	286854	6.1%
water	216852	4.6%
works-street	159398	3.4%
health	143813	3.0%
nhs-animal	139749	3.0%
Other values (206)	1968123	41.7%

Most occurring characters

Value	Count	Frequency (%)
e	4530059	9.3%
i	3300515	6.8%
r	3283333	6.8%
a	3180184	6.6%
	3157835	6.5%
-	3121076	6.4%
t	2853937	5.9%
o	2635467	5.4%
s	2190723	4.5%
n	2099413	4.3%
Other values (43)	18182164	37.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	34166821	70.4%
Uppercase Letter	7973083	16.4%
Space Separator	3157835	6.5%
Dash Punctuation	3121076	6.4%
Decimal Number	114274	0.2%
Other Punctuation	1617	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4530059	13.3%
i	3300515	9.7%
r	3283333	9.6%
a	3180184	9.3%
t	2853937	8.4%
o	2635467	7.7%
s	2190723	6.4%
n	2099413	6.1%
l	1550002	4.5%
d	1511973	4.4%
Other values (14)	7031215	20.6%

Uppercase Letter

Value	Count	Frequency (%)
S	2058471	25.8%
N	1136393	14.3%
W	1020241	12.8%
P	1005647	12.6%
H	976676	12.2%
C	262046	3.3%
A	220751	2.8%
M	215408	2.7%
T	213447	2.7%
L	202835	2.5%
Other values (13)	661168	8.3%

Decimal Number

Value	Count	Frequency (%)
3	50862	44.5%
1	39053	34.2%
2	24359	21.3%

Space Separator

Value	Count	Frequency (%)
	3157835	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3121076	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	1617	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	42139904	86.8%
Common	6394802	13.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4530059	10.8%
i	3300515	7.8%
r	3283333	7.8%
a	3180184	7.5%
t	2853937	6.8%
o	2635467	6.3%
s	2190723	5.2%
n	2099413	5.0%
S	2058471	4.9%
l	1550002	3.7%
Other values (37)	14457800	34.3%

Common

Value	Count	Frequency (%)
	3157835	49.4%
-	3121076	48.8%
3	50862	0.8%
1	39053	0.6%
2	24359	0.4%
&	1617	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48534706	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	4530059	9.3%
i	3300515	6.8%
r	3283333	6.8%
a	3180184	6.6%
	3157835	6.5%
-	3121076	6.4%
t	2853937	5.9%
o	2635467	5.4%
s	2190723	4.5%
n	2099413	4.3%
Other values (43)	18182164	37.5%

TYPE
Text

Distinct	295
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Length

Max length	48
Median length	29
Mean length	11.899895
Min length	2

Characters and Unicode

Total characters	18602094
Distinct characters	69
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	Dangerous Building
2nd row	Crack
3rd row	Dangerous Building
4th row	Property Maintenance
5th row	Park Maintenance

Value	Count	Frequency (%)
property	246467	9.1%
private	213828	7.9%
	118647	4.4%
street	99068	3.7%
trash	70159	2.6%
collection	70001	2.6%
maintenance	65340	2.4%
animal	52113	1.9%
stray	47867	1.8%
pothole	39777	1.5%
Other values (343)	1683117	62.2%

Most occurring characters

Value	Count	Frequency (%)
e	1934335	10.4%
r	1626910	8.7%
t	1536231	8.3%
a	1346391	7.2%
i	1251603	6.7%
	1143169	6.1%
n	1133790	6.1%
o	1009491	5.4%
l	663892	3.6%
P	578906	3.1%
Other values (59)	6377376	34.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14743571	79.3%
Uppercase Letter	2509188	13.5%
Space Separator	1143169	6.1%
Other Punctuation	125515	0.7%
Decimal Number	54301	0.3%
Dash Punctuation	13999	0.1%
Open Punctuation	6102	< 0.1%
Close Punctuation	6102	< 0.1%
Initial Punctuation	147	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1934335	13.1%
r	1626910	11.0%
t	1536231	10.4%
a	1346391	9.1%
i	1251603	8.5%
n	1133790	7.7%
o	1009491	6.8%
l	663892	4.5%
c	562616	3.8%
y	499008	3.4%
Other values (16)	3179304	21.6%

Uppercase Letter

Value	Count	Frequency (%)
P	578906	23.1%
S	289650	11.5%
C	240537	9.6%
R	183614	7.3%
A	162665	6.5%
B	147822	5.9%
T	145769	5.8%
D	118884	4.7%
L	109082	4.3%
M	108032	4.3%
Other values (15)	424227	16.9%

Decimal Number

Value	Count	Frequency (%)
1	14948	27.5%
2	11371	20.9%
0	8742	16.1%
3	3140	5.8%
6	2923	5.4%
8	2812	5.2%
4	2647	4.9%
7	2619	4.8%
9	2608	4.8%
5	2491	4.6%

Other Punctuation

Value	Count	Frequency (%)
/	116109	92.5%
&	9373	7.5%
.	33	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1143169	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13999	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	6102	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	6102	100.0%

Initial Punctuation

Value	Count	Frequency (%)
‘	147	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17252759	92.7%
Common	1349335	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1934335	11.2%
r	1626910	9.4%
t	1536231	8.9%
a	1346391	7.8%
i	1251603	7.3%
n	1133790	6.6%
o	1009491	5.9%
l	663892	3.8%
P	578906	3.4%
c	562616	3.3%
Other values (41)	5608594	32.5%

Common

Value	Count	Frequency (%)
	1143169	84.7%
/	116109	8.6%
1	14948	1.1%
-	13999	1.0%
2	11371	0.8%
&	9373	0.7%
0	8742	0.6%
(	6102	0.5%
)	6102	0.5%
3	3140	0.2%
Other values (8)	16280	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18601947	> 99.9%
Punctuation	147	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1934335	10.4%
r	1626910	8.7%
t	1536231	8.3%
a	1346391	7.2%
i	1251603	6.7%
	1143169	6.1%
n	1133790	6.1%
o	1009491	5.4%
l	663892	3.6%
P	578906	3.1%
Other values (58)	6377229	34.3%

Punctuation

Value	Count	Frequency (%)
‘	147	100.0%

DETAIL
Text

Distinct	574
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Length

Max length	48
Median length	31
Mean length	10.467135
Min length	3

Characters and Unicode

Total characters	16362382
Distinct characters	66
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	36 ?
Unique (%)	< 0.1%

Sample

1st row	Standard
2nd row	District 1
3rd row	Standard
4th row	Other Property Issue
5th row	Central

Value	Count	Frequency (%)
all	428758	14.3%
missed	172087	5.8%
	135089	4.5%
by	107464	3.6%
district	107235	3.6%
contractor	89601	3.0%
property	70100	2.3%
south	69653	2.3%
north	60495	2.0%
one	57947	1.9%
Other values (600)	1693151	56.6%

Most occurring characters

Value	Count	Frequency (%)
e	1505379	9.2%
	1428365	8.7%
t	1310932	8.0%
r	1212748	7.4%
l	1087247	6.6%
i	896135	5.5%
o	845654	5.2%
s	787339	4.8%
n	708151	4.3%
a	643131	3.9%
Other values (56)	5937301	36.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11901213	72.7%
Uppercase Letter	2711940	16.6%
Space Separator	1428365	8.7%
Dash Punctuation	114893	0.7%
Other Punctuation	108326	0.7%
Decimal Number	78896	0.5%
Open Punctuation	8339	0.1%
Close Punctuation	8339	0.1%
Math Symbol	2038	< 0.1%
Initial Punctuation	33	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1505379	12.6%
t	1310932	11.0%
r	1212748	10.2%
l	1087247	9.1%
i	896135	7.5%
o	845654	7.1%
s	787339	6.6%
n	708151	6.0%
a	643131	5.4%
c	431294	3.6%
Other values (16)	2473203	20.8%

Uppercase Letter

Value	Count	Frequency (%)
A	510716	18.8%
S	295407	10.9%
M	234827	8.7%
C	234346	8.6%
D	189901	7.0%
P	175668	6.5%
N	159626	5.9%
L	151890	5.6%
O	134016	4.9%
T	120206	4.4%
Other values (15)	505337	18.6%

Decimal Number

Value	Count	Frequency (%)
3	31985	40.5%
1	22084	28.0%
2	20851	26.4%
5	2038	2.6%
4	1938	2.5%

Other Punctuation

Value	Count	Frequency (%)
/	62947	58.1%
*	45286	41.8%
'	64	0.1%
.	29	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1428365	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	114893	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	8339	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	8339	100.0%

Math Symbol

Value	Count	Frequency (%)
+	2038	100.0%

Initial Punctuation

Value	Count	Frequency (%)
‘	33	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14613153	89.3%
Common	1749229	10.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1505379	10.3%
t	1310932	9.0%
r	1212748	8.3%
l	1087247	7.4%
i	896135	6.1%
o	845654	5.8%
s	787339	5.4%
n	708151	4.8%
a	643131	4.4%
A	510716	3.5%
Other values (41)	5105721	34.9%

Common

Value	Count	Frequency (%)
	1428365	81.7%
-	114893	6.6%
/	62947	3.6%
*	45286	2.6%
3	31985	1.8%
1	22084	1.3%
2	20851	1.2%
(	8339	0.5%
)	8339	0.5%
5	2038	0.1%
Other values (5)	4102	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16362349	> 99.9%
Punctuation	33	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1505379	9.2%
	1428365	8.7%
t	1310932	8.0%
r	1212748	7.4%
l	1087247	6.6%
i	896135	5.5%
o	845654	5.2%
s	787339	4.8%
n	708151	4.3%
a	643131	3.9%
Other values (55)	5937268	36.3%

Punctuation

Value	Count	Frequency (%)
‘	33	100.0%

CREATION DATE
Date

Distinct	5229
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Minimum	2006-12-29 00:00:00
Maximum	2021-10-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

CREATION TIME
Date

Distinct	1440
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Minimum	2024-02-28 00:00:00
Maximum	2024-02-28 23:59:00

Histogram

Histogram with fixed size bins (bins=50)

STATUS
Categorical

IMBALANCE

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

RESOL	1535389
CANC	13818
OPEN	12657
DUP	1301
ASSIG	45

Length

Max length	5
Median length	5
Mean length	4.981396
Min length	3

Characters and Unicode

Total characters	7786993
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RESOL
2nd row	RESOL
3rd row	RESOL
4th row	RESOL
5th row	RESOL

Common Values

Value	Count	Frequency (%)
RESOL	1535389	98.2%
CANC	13818	0.9%
OPEN	12657	0.8%
DUP	1301	0.1%
ASSIG	45	< 0.1%
FAIL	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
resol	1535389	98.2%
canc	13818	0.9%
open	12657	0.8%
dup	1301	0.1%
assig	45	< 0.1%
fail	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	1548046	19.9%
O	1548046	19.9%
S	1535479	19.7%
L	1535394	19.7%
R	1535389	19.7%
C	27636	0.4%
N	26475	0.3%
P	13958	0.2%
A	13868	0.2%
D	1301	< 0.1%
Other values (4)	1401	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7786993	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1548046	19.9%
O	1548046	19.9%
S	1535479	19.7%
L	1535394	19.7%
R	1535389	19.7%
C	27636	0.4%
N	26475	0.3%
P	13958	0.2%
A	13868	0.2%
D	1301	< 0.1%
Other values (4)	1401	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7786993	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1548046	19.9%
O	1548046	19.9%
S	1535479	19.7%
L	1535394	19.7%
R	1535389	19.7%
C	27636	0.4%
N	26475	0.3%
P	13958	0.2%
A	13868	0.2%
D	1301	< 0.1%
Other values (4)	1401	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7786993	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1548046	19.9%
O	1548046	19.9%
S	1535479	19.7%
L	1535394	19.7%
R	1535389	19.7%
C	27636	0.4%
N	26475	0.3%
P	13958	0.2%
A	13868	0.2%
D	1301	< 0.1%
Other values (4)	1401	< 0.1%

EXCEEDED EST TIMEFRAME
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	23
Missing (%)	< 0.1%
Memory size	3.0 MiB

False	1079493
True	483699
(Missing)	23

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1079493	69.1%
True	483699	30.9%
(Missing)	23	< 0.1%

CLOSED DATE
Date

Distinct	4995
Distinct (%)	0.3%
Missing	12702
Missing (%)	0.8%
Memory size	11.9 MiB

Minimum	2007-01-04 00:00:00
Maximum	2022-02-11 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

DAYS TO CLOSE
Real number (ℝ)

MISSING ZEROS

Distinct	2748
Distinct (%)	0.2%
Missing	26515
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	51.533404

Minimum	-21
Maximum	4525
Zeros	150614
Zeros (%)	9.6%
Negative	29
Negative (%)	< 0.1%
Memory size	11.9 MiB

Quantile statistics

Minimum	-21
5-th percentile	0
Q1	1
median	4
Q3	23
95-th percentile	261
Maximum	4525
Range	4546
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	169.57318
Coefficient of variation (CV)	3.2905488
Kurtosis	77.017163
Mean	51.533404
Median Absolute Deviation (MAD)	3
Skewness	7.3881016
Sum	79191382
Variance	28755.063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	322471	20.6%
0	150614	9.6%
2	120416	7.7%
3	103139	6.6%
4	77824	5.0%
5	57503	3.7%
6	49736	3.2%
7	44990	2.9%
8	31128	2.0%
9	20513	1.3%
Other values (2738)	558366	35.7%
(Missing)	26515	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-21	17	< 0.1%
-20	2	< 0.1%
-19	8	< 0.1%
-18	1	< 0.1%
-1	1	< 0.1%
0	150614	9.6%
1	322471	20.6%
2	120416	7.7%
3	103139	6.6%
4	77824	5.0%

Value	Count	Frequency (%)
4525	1	< 0.1%
4471	1	< 0.1%
4396	1	< 0.1%
4188	1	< 0.1%
4183	1	< 0.1%
4175	1	< 0.1%
4160	1	< 0.1%
4157	1	< 0.1%
4135	1	< 0.1%
4132	1	< 0.1%

STREET ADDRESS
Text

Distinct	277728
Distinct (%)	17.8%
Missing	24
Missing (%)	< 0.1%
Memory size	11.9 MiB

Length

Max length	39
Median length	37
Mean length	15.80865
Min length	4

Characters and Unicode

Total characters	24711939
Distinct characters	75
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	67349 ?
Unique (%)	4.3%

Sample

1st row	2317 E 50th St
2nd row	10329 N Forest Ave
3rd row	2623 E 10th St
4th row	2474 Chelsea Ave
5th row	400 W 31st St

Value	Count	Frequency (%)
ave	602207	10.9%
st	476456	8.6%
e	327586	5.9%
n	180177	3.3%
ter	156915	2.8%
rd	131274	2.4%
ne	112479	2.0%
w	70394	1.3%
blvd	64833	1.2%
nw	64756	1.2%
Other values (12145)	3334294	60.4%

Most occurring characters

Value	Count	Frequency (%)
	3958210	16.0%
1	1284556	5.2%
0	1173280	4.7%
E	1116467	4.5%
e	909295	3.7%
A	892797	3.6%
2	785798	3.2%
t	762941	3.1%
T	726450	2.9%
3	717530	2.9%
Other values (65)	12384615	50.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7637289	30.9%
Decimal Number	7183875	29.1%
Lowercase Letter	5925190	24.0%
Space Separator	3958210	16.0%
Dash Punctuation	5688	< 0.1%
Other Punctuation	1677	< 0.1%
Open Punctuation	5	< 0.1%
Close Punctuation	5	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1116467	14.6%
A	892797	11.7%
T	726450	9.5%
S	694753	9.1%
N	661679	8.7%
R	501664	6.6%
V	331386	4.3%
W	291712	3.8%
L	290404	3.8%
O	286483	3.8%
Other values (16)	1843494	24.1%

Lowercase Letter

Value	Count	Frequency (%)
e	909295	15.3%
t	762941	12.9%
r	482556	8.1%
v	427188	7.2%
n	420855	7.1%
a	372413	6.3%
o	364188	6.1%
l	354868	6.0%
d	338821	5.7%
h	306003	5.2%
Other values (16)	1186062	20.0%

Decimal Number

Value	Count	Frequency (%)
1	1284556	17.9%
0	1173280	16.3%
2	785798	10.9%
3	717530	10.0%
4	714711	9.9%
5	619841	8.6%
6	496732	6.9%
7	496633	6.9%
8	477639	6.6%
9	417155	5.8%

Other Punctuation

Value	Count	Frequency (%)
'	1342	80.0%
,	100	6.0%
.	70	4.2%
/	70	4.2%
#	68	4.1%
&	13	0.8%
"	10	0.6%
:	3	0.2%
%	1	0.1%

Space Separator

Value	Count	Frequency (%)
	3958210	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5688	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	5	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13562479	54.9%
Common	11149460	45.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1116467	8.2%
e	909295	6.7%
A	892797	6.6%
t	762941	5.6%
T	726450	5.4%
S	694753	5.1%
N	661679	4.9%
R	501664	3.7%
r	482556	3.6%
v	427188	3.1%
Other values (42)	6386689	47.1%

Common

Value	Count	Frequency (%)
	3958210	35.5%
1	1284556	11.5%
0	1173280	10.5%
2	785798	7.0%
3	717530	6.4%
4	714711	6.4%
5	619841	5.6%
6	496732	4.5%
7	496633	4.5%
8	477639	4.3%
Other values (13)	424530	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24711939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3958210	16.0%
1	1284556	5.2%
0	1173280	4.7%
E	1116467	4.5%
e	909295	3.7%
A	892797	3.6%
2	785798	3.2%
t	762941	3.1%
T	726450	2.9%
3	717530	2.9%
Other values (65)	12384615	50.1%

ZIP CODE
Real number (ℝ)

SKEWED

Distinct	65
Distinct (%)	< 0.1%
Missing	826
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	64126.843

Minimum	4114
Maximum	66203
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	4114
5-th percentile	64109
Q1	64116
median	64128
Q3	64133
95-th percentile	64155
Maximum	66203
Range	62089
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	68.122948
Coefficient of variation (CV)	0.0010623156
Kurtosis	721225.59
Mean	64126.843
Median Absolute Deviation (MAD)	9
Skewness	-832.06849
Sum	1.0019107 × 10¹¹
Variance	4640.7361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
64130	133154	8.5%
64127	90867	5.8%
64114	83166	5.3%
64134	77097	4.9%
64131	76437	4.9%
64132	76361	4.9%
64128	73073	4.7%
64110	64771	4.1%
64119	57224	3.7%
64111	50195	3.2%
Other values (55)	780044	49.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4114	1	< 0.1%
6152	1	< 0.1%
63130	1	< 0.1%
64012	39	< 0.1%
64028	22	< 0.1%
64030	27	< 0.1%
64052	47	< 0.1%
64053	115	< 0.1%
64055	28	< 0.1%
64068	280	< 0.1%

Value	Count	Frequency (%)
66203	1	< 0.1%
64444	15	< 0.1%
64167	194	< 0.1%
64166	460	< 0.1%
64165	486	< 0.1%
64164	522	< 0.1%
64163	1160	0.1%
64161	1936	0.1%
64160	89	< 0.1%
64158	6892	0.4%

NEIGHBORHOOD
Text

MISSING

Distinct	250
Distinct (%)	< 0.1%
Missing	46106
Missing (%)	2.9%
Memory size	11.9 MiB

Length

Max length	42
Median length	29
Mean length	14.972397
Min length	2

Characters and Unicode

Total characters	22714758
Distinct characters	60
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Blue Hills
2nd row	New Mark
3rd row	Independence Plaza
4th row	East Community Team South
5th row	Westside South

Value	Count	Frequency (%)
park	147748	4.3%
hills	128098	3.7%
east	108867	3.2%
creek	104581	3.0%
blue	98087	2.8%
south	98018	2.8%
north	94066	2.7%
and	77209	2.2%
shoal	59166	1.7%
oak	59067	1.7%
Other values (269)	2476354	71.8%

Most occurring characters

Value	Count	Frequency (%)
e	2024521	8.9%
	1934152	8.5%
a	1649498	7.3%
o	1561057	6.9%
r	1370100	6.0%
t	1291903	5.7%
l	1174709	5.2%
n	1168235	5.1%
s	1134269	5.0%
i	1065864	4.7%
Other values (50)	8340450	36.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	17008571	74.9%
Uppercase Letter	3515573	15.5%
Space Separator	1934152	8.5%
Decimal Number	140924	0.6%
Dash Punctuation	82454	0.4%
Other Punctuation	33084	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2024521	11.9%
a	1649498	9.7%
o	1561057	9.2%
r	1370100	8.1%
t	1291903	7.6%
l	1174709	6.9%
n	1168235	6.9%
s	1134269	6.7%
i	1065864	6.3%
h	746484	4.4%
Other values (15)	3821931	22.5%

Uppercase Letter

Value	Count	Frequency (%)
S	367459	10.5%
C	360417	10.3%
H	349438	9.9%
P	322701	9.2%
W	224225	6.4%
M	205260	5.8%
E	203178	5.8%
B	195938	5.6%
N	186385	5.3%
R	155777	4.4%
Other values (13)	944795	26.9%

Decimal Number

Value	Count	Frequency (%)
6	37402	26.5%
9	25165	17.9%
4	25165	17.9%
3	25165	17.9%
2	13161	9.3%
7	10056	7.1%
1	2405	1.7%
8	2405	1.7%

Other Punctuation

Value	Count	Frequency (%)
/	19923	60.2%
&	13161	39.8%

Space Separator

Value	Count	Frequency (%)
	1934152	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	82454	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20524144	90.4%
Common	2190614	9.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2024521	9.9%
a	1649498	8.0%
o	1561057	7.6%
r	1370100	6.7%
t	1291903	6.3%
l	1174709	5.7%
n	1168235	5.7%
s	1134269	5.5%
i	1065864	5.2%
h	746484	3.6%
Other values (38)	7337504	35.8%

Common

Value	Count	Frequency (%)
	1934152	88.3%
-	82454	3.8%
6	37402	1.7%
9	25165	1.1%
4	25165	1.1%
3	25165	1.1%
/	19923	0.9%
2	13161	0.6%
&	13161	0.6%
7	10056	0.5%
Other values (2)	4810	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22714758	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2024521	8.9%
	1934152	8.5%
a	1649498	7.3%
o	1561057	6.9%
r	1370100	6.0%
t	1291903	5.7%
l	1174709	5.2%
n	1168235	5.1%
s	1134269	5.0%
i	1065864	4.7%
Other values (50)	8340450	36.7%

COUNTY
Categorical

IMBALANCE MISSING

Distinct	13
Distinct (%)	< 0.1%
Missing	66959
Missing (%)	4.3%
Memory size	11.9 MiB

Jackson	1165976
Clay	248388
Platte	80799
CLAY	573
Cass	228
Other values (8)	292

Length

Max length	13
Median length	7
Mean length	6.4463307
Min length	4

Characters and Unicode

Total characters	9645361
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Jackson
2nd row	Clay
3rd row	Jackson
4th row	Jackson
5th row	Jackson

Common Values

Value	Count	Frequency (%)
Jackson	1165976	74.6%
Clay	248388	15.9%
Platte	80799	5.2%
CLAY	573	< 0.1%
Cass	228	< 0.1%
JACKSON	219	< 0.1%
jackson	41	< 0.1%
clay	23	< 0.1%
platte	4	< 0.1%
Platte County	2	< 0.1%
Other values (3)	3	< 0.1%
(Missing)	66959	4.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
jackson	1166236	77.9%
clay	248984	16.6%
platte	80806	5.4%
cass	228	< 0.1%
county	2	< 0.1%
clayl	1	< 0.1%
ackson	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	1495463	15.5%
s	1166474	12.1%
J	1166195	12.1%
c	1166041	12.1%
o	1166020	12.1%
n	1166020	12.1%
k	1166018	12.1%
l	329218	3.4%
C	249411	2.6%
y	248414	2.6%
Other values (16)	326087	3.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8146132	84.5%
Uppercase Letter	1499227	15.5%
Space Separator	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1495463	18.4%
s	1166474	14.3%
c	1166041	14.3%
o	1166020	14.3%
n	1166020	14.3%
k	1166018	14.3%
l	329218	4.0%
y	248414	3.0%
t	161612	2.0%
e	80805	1.0%
Other values (3)	47	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
J	1166195	77.8%
C	249411	16.6%
P	80802	5.4%
A	793	0.1%
L	574	< 0.1%
Y	573	< 0.1%
K	219	< 0.1%
S	219	< 0.1%
O	219	< 0.1%
N	219	< 0.1%
Other values (2)	3	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9645359	> 99.9%
Common	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1495463	15.5%
s	1166474	12.1%
J	1166195	12.1%
c	1166041	12.1%
o	1166020	12.1%
n	1166020	12.1%
k	1166018	12.1%
l	329218	3.4%
C	249411	2.6%
y	248414	2.6%
Other values (15)	326085	3.4%

Common

Value	Count	Frequency (%)
	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9645361	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1495463	15.5%
s	1166474	12.1%
J	1166195	12.1%
c	1166041	12.1%
o	1166020	12.1%
n	1166020	12.1%
k	1166018	12.1%
l	329218	3.4%
C	249411	2.6%
y	248414	2.6%
Other values (16)	326087	3.4%

POLICE DISTRICT
Categorical

MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	35265
Missing (%)	2.3%
Memory size	11.9 MiB

Metro	383130
East	374326
Central	234327
Shoal Creek	209760
South	201792

Length

Max length	11
Median length	7
Mean length	5.8854269
Min length	4

Characters and Unicode

Total characters	8992638
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Metro
2nd row	Shoal Creek
3rd row	East
4th row	East
5th row	Central

Common Values

Value	Count	Frequency (%)
Metro	383130	24.5%
East	374326	23.9%
Central	234327	15.0%
Shoal Creek	209760	13.4%
South	201792	12.9%
North	124615	8.0%
(Missing)	35265	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
metro	383130	22.0%
east	374326	21.5%
central	234327	13.5%
shoal	209760	12.1%
creek	209760	12.1%
south	201792	11.6%
north	124615	7.2%

Most occurring characters

Value	Count	Frequency (%)
t	1318190	14.7%
e	1036977	11.5%
r	951832	10.6%
o	919297	10.2%
a	818413	9.1%
h	536167	6.0%
C	444087	4.9%
l	444087	4.9%
S	411552	4.6%
M	383130	4.3%
Other values (7)	1728906	19.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7045168	78.3%
Uppercase Letter	1737710	19.3%
Space Separator	209760	2.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1318190	18.7%
e	1036977	14.7%
r	951832	13.5%
o	919297	13.0%
a	818413	11.6%
h	536167	7.6%
l	444087	6.3%
s	374326	5.3%
n	234327	3.3%
k	209760	3.0%

Uppercase Letter

Value	Count	Frequency (%)
C	444087	25.6%
S	411552	23.7%
M	383130	22.0%
E	374326	21.5%
N	124615	7.2%

Space Separator

Value	Count	Frequency (%)
	209760	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8782878	97.7%
Common	209760	2.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	1318190	15.0%
e	1036977	11.8%
r	951832	10.8%
o	919297	10.5%
a	818413	9.3%
h	536167	6.1%
C	444087	5.1%
l	444087	5.1%
S	411552	4.7%
M	383130	4.4%
Other values (6)	1519146	17.3%

Common

Value	Count	Frequency (%)
	209760	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8992638	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	1318190	14.7%
e	1036977	11.5%
r	951832	10.6%
o	919297	10.2%
a	818413	9.1%
h	536167	6.0%
C	444087	4.9%
l	444087	4.9%
S	411552	4.6%
M	383130	4.3%
Other values (7)	1728906	19.2%

PARCEL ID NO
Real number (ℝ)

SKEWED ZEROS

Distinct	175953
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106754.49

Minimum	0
Maximum	9.9589235 × 10⁸
Zeros	35266
Zeros (%)	2.3%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	0
5-th percentile	3898
Q1	38358
median	85391
Q3	136854
95-th percentile	228308
Maximum	9.9589235 × 10⁸
Range	9.9589235 × 10⁸
Interquartile range (IQR)	98496

Descriptive statistics

Standard deviation	2353178.5
Coefficient of variation (CV)	22.042899
Kurtosis	76590.509
Mean	106754.49
Median Absolute Deviation (MAD)	49221
Skewness	250.90887
Sum	1.6688022 × 10¹¹
Variance	5.5374489 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35266	2.3%
12614	4942	0.3%
492	2754	0.2%
12926	1265	0.1%
128568	542	< 0.1%
99048	520	< 0.1%
98624	450	< 0.1%
142693	433	< 0.1%
12635	414	< 0.1%
127254	360	< 0.1%
Other values (175943)	1516269	97.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35266	2.3%
1	28	< 0.1%
5	13	< 0.1%
6	1	< 0.1%
7	142	< 0.1%
10	30	< 0.1%
12	23	< 0.1%
14	3	< 0.1%
17	72	< 0.1%
18	42	< 0.1%

Value	Count	Frequency (%)
995892354	1	< 0.1%
935159351	1	< 0.1%
675192432	4	< 0.1%
673306734	1	< 0.1%
672126721	1	< 0.1%
647706478	1	< 0.1%
647476476	1	< 0.1%
620486201	1	< 0.1%
485674857	1	< 0.1%
250613250	3	< 0.1%

LATITUDE
Real number (ℝ)

Distinct	157747
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.985272

Minimum	35.797519
Maximum	39.35464
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	35.797519
5-th percentile	38.915251
Q1	38.997002
median	39.054552
Q3	39.109302
95-th percentile	39.257015
Maximum	39.35464
Range	3.557121
Interquartile range (IQR)	0.1123

Descriptive statistics

Standard deviation	0.52951741
Coefficient of variation (CV)	0.013582499
Kurtosis	31.132856
Mean	38.985272
Median Absolute Deviation (MAD)	0.056051
Skewness	-5.6446435
Sum	60942361
Variance	0.28038868
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.797519	40610	2.6%
39.100387	4940	0.3%
39.014493	2469	0.2%
39.099123	1246	0.1%
39.074934	476	< 0.1%
39.285963	380	< 0.1%
39.031378	374	< 0.1%
39.100349	371	< 0.1%
39.307933	360	< 0.1%
39.074825	312	< 0.1%
Other values (157737)	1511677	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
35.797519	40610	2.6%
38.827084	1	< 0.1%
38.83482	5	< 0.1%
38.835025	6	< 0.1%
38.838219	29	< 0.1%
38.838324	5	< 0.1%
38.838331	34	< 0.1%
38.838343	3	< 0.1%
38.838587	8	< 0.1%
38.838841	4	< 0.1%

Value	Count	Frequency (%)
39.35464	5	< 0.1%
39.354635	2	< 0.1%
39.354631	1	< 0.1%
39.354629	6	< 0.1%
39.354601	3	< 0.1%
39.354591	5	< 0.1%
39.354575	16	< 0.1%
39.353859	1	< 0.1%
39.353853	3	< 0.1%
39.353638	1	< 0.1%

LONGITUDE
Real number (ℝ)

Distinct	126281
Distinct (%)	8.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-94.792875

Minimum	-103.89058
Maximum	-94.386375
Zeros	0
Zeros (%)	0.0%
Negative	1563215
Negative (%)	100.0%
Memory size	11.9 MiB

Quantile statistics

Minimum	-103.89058
5-th percentile	-94.645131
Q1	-94.583575
median	-94.55375
Q3	-94.523262
95-th percentile	-94.474424
Maximum	-94.386375
Range	9.504204
Interquartile range (IQR)	0.060313

Descriptive statistics

Standard deviation	1.4864643
Coefficient of variation (CV)	-0.015681181
Kurtosis	33.45319
Mean	-94.792875
Median Absolute Deviation (MAD)	0.030071
Skewness	-5.9512036
Sum	-1.4818164 × 10⁸
Variance	2.209576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-103.890579	40610	2.6%
-94.577919	4958	0.3%
-94.529933	2472	0.2%
-94.577983	1246	0.1%
-94.591904	481	< 0.1%
-94.576776	414	< 0.1%
-94.472954	378	< 0.1%
-94.540878	372	< 0.1%
-94.59448	370	< 0.1%
-94.588552	320	< 0.1%
Other values (126271)	1511594	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-103.890579	40610	2.6%
-94.756681	1	< 0.1%
-94.756298	1	< 0.1%
-94.754146	1	< 0.1%
-94.752204	1	< 0.1%
-94.752202	1	< 0.1%
-94.752171	12	< 0.1%
-94.75217	2	< 0.1%
-94.752163	8	< 0.1%
-94.752122	2	< 0.1%

Value	Count	Frequency (%)
-94.386375	26	< 0.1%
-94.386377	2	< 0.1%
-94.386465	1	< 0.1%
-94.386516	13	< 0.1%
-94.386648	12	< 0.1%
-94.386673	1	< 0.1%
-94.386677	8	< 0.1%
-94.386711	3	< 0.1%
-94.386814	2	< 0.1%
-94.386906	2	< 0.1%

CATEGORY1
Text

Distinct	82
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.9 MiB

Length

Max length	33
Median length	27
Mean length	9.007958
Min length	3

Characters and Unicode

Total characters	14081375
Distinct characters	47
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Property
2nd row	Streets
3rd row	Property
4th row	Property
5th row	Parks & Recreation

Value	Count	Frequency (%)
trash	373808	17.4%
property	232185	10.8%
violations	199740	9.3%
water	185164	8.6%
animal	98921	4.6%
streets	74919	3.5%
trees	73966	3.4%
animals	73694	3.4%
leak	71347	3.3%
nuisance	65646	3.0%
Other values (93)	703849	32.7%

Most occurring characters

Value	Count	Frequency (%)
r	1368856	9.7%
e	1281014	9.1%
a	1209121	8.6%
t	1099999	7.8%
s	1011493	7.2%
i	990455	7.0%
o	868987	6.2%
n	672691	4.8%
	590024	4.2%
l	571371	4.1%
Other values (37)	4417364	31.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11341069	80.5%
Uppercase Letter	2092916	14.9%
Space Separator	590024	4.2%
Other Punctuation	57366	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	1368856	12.1%
e	1281014	11.3%
a	1209121	10.7%
t	1099999	9.7%
s	1011493	8.9%
i	990455	8.7%
o	868987	7.7%
n	672691	5.9%
l	571371	5.0%
h	515296	4.5%
Other values (14)	1751786	15.4%

Uppercase Letter

Value	Count	Frequency (%)
T	457894	21.9%
P	317558	15.2%
S	274981	13.1%
V	248665	11.9%
W	225868	10.8%
A	201518	9.6%
L	119789	5.7%
N	70214	3.4%
M	49609	2.4%
B	27456	1.3%
Other values (11)	99364	4.7%

Space Separator

Value	Count	Frequency (%)
	590024	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	57366	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13433985	95.4%
Common	647390	4.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	1368856	10.2%
e	1281014	9.5%
a	1209121	9.0%
t	1099999	8.2%
s	1011493	7.5%
i	990455	7.4%
o	868987	6.5%
n	672691	5.0%
l	571371	4.3%
h	515296	3.8%
Other values (35)	3844702	28.6%

Common

Value	Count	Frequency (%)
	590024	91.1%
&	57366	8.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14081375	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	1368856	9.7%
e	1281014	9.1%
a	1209121	8.6%
t	1099999	7.8%
s	1011493	7.2%
i	990455	7.0%
o	868987	6.2%
n	672691	4.8%
	590024	4.2%
l	571371	4.1%
Other values (37)	4417364	31.4%

CATEGORY2
Categorical

MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	1001657
Missing (%)	64.1%
Memory size	11.9 MiB

Recycling	205683
Roadways	74919
Pets	73694
Buildings	73234
Weeds	35304
Other values (4)	98724

Length

Max length	9
Median length	8
Mean length	7.4557161
Min length	4

Characters and Unicode

Total characters	4186817
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Buildings
2nd row	Roadways
3rd row	Buildings
4th row	Buildings
5th row	Buildings

Common Values

Value	Count	Frequency (%)
Recycling	205683	13.2%
Roadways	74919	4.8%
Pets	73694	4.7%
Buildings	73234	4.7%
Weeds	35304	2.3%
Sewer	32457	2.1%
Parking	29902	1.9%
Signals	26246	1.7%
Curbs	10119	0.6%
(Missing)	1001657	64.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
recycling	205683	36.6%
roadways	74919	13.3%
pets	73694	13.1%
buildings	73234	13.0%
weeds	35304	6.3%
sewer	32457	5.8%
parking	29902	5.3%
signals	26246	4.7%
curbs	10119	1.8%

Most occurring characters

Value	Count	Frequency (%)
e	414899	9.9%
c	411366	9.8%
i	408299	9.8%
n	335065	8.0%
g	335065	8.0%
l	305163	7.3%
s	293516	7.0%
R	280602	6.7%
y	280602	6.7%
a	205986	4.9%
Other values (13)	916254	21.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3625259	86.6%
Uppercase Letter	561558	13.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	414899	11.4%
c	411366	11.3%
i	408299	11.3%
n	335065	9.2%
g	335065	9.2%
l	305163	8.4%
s	293516	8.1%
y	280602	7.7%
a	205986	5.7%
d	183457	5.1%
Other values (7)	451841	12.5%

Uppercase Letter

Value	Count	Frequency (%)
R	280602	50.0%
P	103596	18.4%
B	73234	13.0%
S	58703	10.5%
W	35304	6.3%
C	10119	1.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4186817	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	414899	9.9%
c	411366	9.8%
i	408299	9.8%
n	335065	8.0%
g	335065	8.0%
l	305163	7.3%
s	293516	7.0%
R	280602	6.7%
y	280602	6.7%
a	205986	4.9%
Other values (13)	916254	21.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4186817	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	414899	9.9%
c	411366	9.8%
i	408299	9.8%
n	335065	8.0%
g	335065	8.0%
l	305163	7.3%
s	293516	7.0%
R	280602	6.7%
y	280602	6.7%
a	205986	4.9%
Other values (13)	916254	21.9%

CATEGORY3
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	1404943
Missing (%)	89.9%
Memory size	11.9 MiB

Alleys	74919
Construction	73234
Ditch	10119

Length

Max length	12
Median length	6
Mean length	8.7123244
Min length	5

Characters and Unicode

Total characters	1378917
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Construction
2nd row	Alleys
3rd row	Construction
4th row	Construction
5th row	Construction

Common Values

Value	Count	Frequency (%)
Alleys	74919	4.8%
Construction	73234	4.7%
Ditch	10119	0.6%
(Missing)	1404943	89.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
alleys	74919	47.3%
construction	73234	46.3%
ditch	10119	6.4%

Most occurring characters

Value	Count	Frequency (%)
t	156587	11.4%
l	149838	10.9%
s	148153	10.7%
o	146468	10.6%
n	146468	10.6%
c	83353	6.0%
i	83353	6.0%
A	74919	5.4%
e	74919	5.4%
y	74919	5.4%
Other values (5)	239940	17.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1220645	88.5%
Uppercase Letter	158272	11.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	156587	12.8%
l	149838	12.3%
s	148153	12.1%
o	146468	12.0%
n	146468	12.0%
c	83353	6.8%
i	83353	6.8%
e	74919	6.1%
y	74919	6.1%
r	73234	6.0%
Other values (2)	83353	6.8%

Uppercase Letter

Value	Count	Frequency (%)
A	74919	47.3%
C	73234	46.3%
D	10119	6.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1378917	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	156587	11.4%
l	149838	10.9%
s	148153	10.7%
o	146468	10.6%
n	146468	10.6%
c	83353	6.0%
i	83353	6.0%
A	74919	5.4%
e	74919	5.4%
y	74919	5.4%
Other values (5)	239940	17.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1378917	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	156587	11.4%
l	149838	10.9%
s	148153	10.7%
o	146468	10.6%
n	146468	10.6%
c	83353	6.0%
i	83353	6.0%
A	74919	5.4%
e	74919	5.4%
y	74919	5.4%
Other values (5)	239940	17.4%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	CASE ID	SOURCE	DEPARTMENT	WORK GROUP	TYPE	DETAIL	CREATION DATE	CREATION TIME	STATUS	EXCEEDED EST TIMEFRAME	CLOSED DATE	DAYS TO CLOSE	STREET ADDRESS	ZIP CODE	NEIGHBORHOOD	COUNTY	POLICE DISTRICT	PARCEL ID NO	LATITUDE	LONGITUDE	CATEGORY1	CATEGORY2	CATEGORY3
0	2019119972	PHONE	NHS	NHS-Dangerous Buildings-	Dangerous Building	Standard	06/24/2019	07:40 AM	RESOL	Y	11/19/2021	879.0	2317 E 50th St	64130.0	Blue Hills	Jackson	Metro	138863	39.035489	-94.557309	Property	Buildings	Construction
1	2019207923	WEB	Public Works	Public Works-Street and Traffic-District 1	Crack	District 1	12/22/2019	07:56 PM	RESOL	Y	06/26/2020	187.0	10329 N Forest Ave	64155.0	New Mark	Clay	Shoal Creek	103703	39.281960	-94.564453	Streets	Roadways	Alleys
2	2021005976	PHONE	NHS	NHS-Dangerous Buildings-	Dangerous Building	Standard	01/19/2021	02:43 PM	RESOL	Y	11/15/2021	300.0	2623 E 10th St	64127.0	Independence Plaza	Jackson	East	10703	39.101272	-94.549951	Property	Buildings	Construction
3	2020149407	PHONE	NHS	NHS-Neighborhood Preservation-	Property Maintenance	Other Property Issue	11/25/2020	09:19 AM	RESOL	Y	04/26/2021	152.0	2474 Chelsea Ave	64127.0	East Community Team South	Jackson	East	19178	39.079895	-94.526959	Property	Buildings	Construction
4	2020054721	WEB	Parks and Rec	Parks and Rec-Central Region-	Park Maintenance	Central	04/18/2020	05:10 PM	RESOL	N	04/30/2020	12.0	400 W 31st St	64108.0	Westside South	Jackson	Central	128568	39.074934	-94.591904	Parks & Recreation	NaN	NaN
5	2019182182	PHONE	NHS	NHS-Dangerous Buildings-	Dangerous Building	Standard	10/21/2019	10:29 AM	RESOL	Y	08/03/2020	287.0	4043 Kenwood Ave	64110.0	South Hyde Park	Jackson	Central	133291	39.052983	-94.577808	Property	Buildings	Construction
6	2019184705	WEB	NHS	NHS-Solid Waste-	Recycling	Missed by City	10/25/2019	10:02 AM	RESOL	N	10/28/2019	3.0	637 E 62nd St	64110.0	Western 49-63	Jackson	Metro	106106	39.014160	-94.579673	Trash	Recycling	NaN
7	2019184590	WEB	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trimming	Tree Limbs	10/25/2019	04:44 AM	RESOL	Y	12/04/2019	40.0	10901 Blue Ridge Blvd	64134.0	Ruskin Heights	Jackson	South	59546	38.924085	-94.507192	Trees	NaN	NaN
8	2020095175	PHONE	NHS	NHS-Dangerous Buildings-	Dangerous Building	Standard	07/13/2020	08:00 AM	RESOL	Y	11/29/2021	504.0	4215 E 60th St	64130.0	Swope Parkway-Elmwood	Jackson	Metro	326	39.016565	-94.536611	Property	Buildings	Construction
9	2015094486	PHONE	NHS	NHS-Solid Waste-Administration	Services	Service Issue / Problem	08/07/2015	01:45 PM	RESOL	Y	05/27/2016	294.0	4518 N Askew Ave	64117.0	Antioch Acres	Clay	Shoal Creek	76946	39.176846	-94.537416	Trash	Recycling	NaN

	CASE ID	SOURCE	DEPARTMENT	WORK GROUP	TYPE	DETAIL	CREATION DATE	CREATION TIME	STATUS	EXCEEDED EST TIMEFRAME	CLOSED DATE	DAYS TO CLOSE	STREET ADDRESS	ZIP CODE	NEIGHBORHOOD	COUNTY	POLICE DISTRICT	PARCEL ID NO	LATITUDE	LONGITUDE	CATEGORY1	CATEGORY2	CATEGORY3
1563205	2019175846	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Removal	Declining	10/04/2019	11:35 AM	RESOL	Y	12/04/2019	61.0	3942 Wyandotte St	64111.0	Old Westport	Jackson	Central	132644	39.055001	-94.588843	Trees	NaN	NaN
1563206	2019175727	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Removal	Tree Limbs	10/04/2019	09:32 AM	RESOL	Y	11/05/2019	32.0	9014 E 88th Ter	64138.0	White Oak	Jackson	South	66408	38.962712	-94.478245	Trees	NaN	NaN
1563207	2019176019	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trimming	Block Pruning	10/04/2019	03:51 PM	RESOL	N	10/11/2019	7.0	9208 NE 109th Ct	64157.0	Shoal Creek	Clay	Shoal Creek	209678	39.289643	-94.464390	Trees	NaN	NaN
1563208	2019175967	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trimming	Tree Limbs	10/04/2019	02:46 PM	RESOL	Y	10/30/2019	26.0	3106 Peery Ave	64127.0	Independence Plaza	Jackson	East	10876	39.099803	-94.545545	Trees	NaN	NaN
1563209	2019175920	PHONE	Parks and Rec	Parks and Rec-Landscape Services-Forestry	Trimming	Tree Limbs	10/04/2019	01:04 PM	RESOL	Y	10/19/2019	15.0	5048 NE 56th Pl	64119.0	Ravenwood-Somerset	Clay	Shoal Creek	90408	39.195871	-94.518434	Trees	NaN	NaN
1563210	2019175624	PHONE	NHS	NHS-Solid Waste-	Trash Collection	Missed by Contractor North	10/03/2019	06:18 PM	RESOL	N	10/05/2019	2.0	10415 NW 87th St	64153.0	KCI & 2nd Creek	Platte	North	211724	39.251356	-94.702155	Trash	Recycling	NaN
1563211	2019176099	PHONE	Parks and Rec	Parks and Rec-Central Region-	Park Maintenance	Central	10/05/2019	08:13 AM	RESOL	N	10/10/2019	5.0	2308 Topping Ave	64127.0	South Blue Valley	Jackson	East	20118	39.082634	-94.515668	Parks & Recreation	NaN	NaN
1563212	2019176030	PHONE	NHS	NHS-Solid Waste-	Dead Animal	Curb	10/04/2019	04:07 PM	RESOL	N	10/05/2019	1.0	5437 South Benton Ave	64130.0	North Town Fork Creek	Jackson	Metro	36265	39.026897	-94.551349	Animals	Pets	NaN
1563213	2019176115	PHONE	Public Works	Public Works-Capital Projects-Traffic Permits	Plate	Missing / Displaced	10/05/2019	04:50 PM	RESOL	Y	12/04/2019	60.0	1201 W 75th St	64114.0	Ward Parkway	Jackson	Metro	120444	38.992568	-94.604029	Streets	Roadways	Alleys
1563214	2019172858	WEB	City Planning and Development	City Planning and Development-Permit Compliance-	Construction Issue/Concern	Work Without Permit	09/27/2019	08:01 PM	RESOL	Y	10/06/2019	9.0	10799 NW Skyview Ave	64154.0	KCI & 2nd Creek	Platte	North	207756	39.288525	-94.651254	Property	Buildings	Construction

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Initial Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Initial Punctuation

Most occurring scripts